MySQL Server¶
version: 2.3
Compatibility: v 7.6.4
Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Metric Collection Interval (Mandatory)
Operation: monitors the MySQL Server.
Change from Last version: Improved Security Vulnerabilities
Plugin-Metrics:
MySQL Server¶
version: 2.2
Compatibility: v 7.5.3
Requires: Host/IP/CIDR/CSV (Mandatory), Port (Mandatory), Username (Mandatory), Password (Mandatory), Database Name (Mandatory), Metric Collection Interval (Mandatory)
Operation: monitors the MySQL Server.
Plugin-Metrics:
MySQL Server¶
Metric |
Data Type |
Installation Directory |
String |
Data Directory |
String |
UpTime |
String |
Version |
String |
System UpTime (Seconds) |
Numeric |
Aborted Clients |
Numeric |
Aborted Connections |
Numeric |
Received Bytes |
Numeric |
Received Bytes/sec |
Numeric |
Sent Bytes |
Numeric |
Sent Bytes/sec |
Numeric |
Connections |
Numeric |
Connections/sec |
Numeric |
MySQL Questions |
Numeric |
Connection Timeout (MS) |
Numeric |
Open Connections |
Numeric |
Delayed Errors |
Numeric |
Delayed Writes |
Numeric |
MySQL Flushes |
Numeric |
MySQL Flushes/sec |
Numeric |
Key Used Blocks |
Numeric |
Key Read Requests |
Numeric |
Key Reads |
Numeric |
Key Writes |
Numeric |
Key Write Requests |
Numeric |
Not Flushed Delayed Rows |
Numeric |
Deleted Rows |
Numeric |
Deleted Rows/sec |
Numeric |
Inserted Rows |
Numeric |
Inserted Rows/sec |
Numeric |
Read Rows From Fixed Position |
Numeric |
Next Row Read |
Numeric |
Previous Row Read |
Numeric |
Previous Row Read/sec |
Numeric |
Read First Row |
Numeric |
Read First Row/sec |
Numeric |
Read Keys |
Numeric |
Updated Rows |
Numeric |
Updated Rows/sec |
Numeric |
Delayed Insert Threads |
Numeric |
Slow Launch Threads |
Numeric |
Cached Threads |
Numeric |
Connected Threads |
Numeric |
Created Threads |
Numeric |
Running Threads |
Numeric |
Thread Cache size |
Numeric |
Open Tables |
Numeric |
Open Files |
Numeric |
Open Streams |
Numeric |
Select Full Joins |
Numeric |
Select Range |
Numeric |
Select Range Check |
Numeric |
Select Scans |
Numeric |
Slave Open Temp Tables |
Numeric |
Slow Queries |
Numeric |
Sort Merge Passes |
Numeric |
Sort Ranges |
Numeric |
Table Lock Waited |
Numeric |
Table Locks Immediate |
Numeric |
Created Temp Disk Tables |
Numeric |
Created Temp Files |
Numeric |
Created Temp Tables |
Numeric |
Query Cache Limit |
Numeric |
Query Cache Hits |
Numeric |
Query Cache Inserts |
Numeric |
Query Cache Hit Ratio (%) |
Numeric |
Key Buffer Size (KB) |
Numeric |
Used Key Blocks |
Numeric |
Key Hit Ratio (%) |
Numeric |
Admin Commands |
Numeric |
Analyze Commands |
Numeric |
Backup Tables Commands |
Numeric |
Change Database Commands |
Numeric |
Change Master Commands |
Numeric |
Check Commands |
Numeric |
Create Database Commands |
Numeric |
Drop Database Commands |
Numeric |
Flush Commands |
Numeric |
Grant Commands |
Numeric |
Kill Commands |
Numeric |
Optimize Commands |
Numeric |
Repair Commands |
Numeric |
Reset Commands |
Numeric |
Revoke Commands |
Numeric |
Alter Table Commands |
Numeric |
Create Function Commands |
Numeric |
Create Index Commands |
Numeric |
Create Table Commands |
Numeric |
Drop Function Commands |
Numeric |
Drop Index Commands |
Numeric |
Drop Table Commands |
Numeric |
Rename Table Commands |
Numeric |
Delete Multi Commands |
Numeric |
Handler Close Commands |
Numeric |
Handler Open Commands |
Numeric |
Handler Read Commands |
Numeric |
Master Data Commands |
Numeric |
Select Commands |
Numeric |
Set Option Commands |
Numeric |
Slave Start Commands |
Numeric |
Slave Stop Commands |
Numeric |
Delete Commands |
Numeric |
Insert Commands |
Numeric |
Insert Select Commands |
Numeric |
Load Commands |
Numeric |
Load Master Table Commands |
Numeric |
Purge Commands |
Numeric |
Replace Commands |
Numeric |
Replace Select Commands |
Numeric |
Restore Table Commands |
Numeric |
Truncate Commands |
Numeric |
Update Commands |
Numeric |
Show Binary logs Commands |
Numeric |
Show binary Log Events Commands |
Numeric |
Show Databases Commands |
Numeric |
Show Field Commands |
Numeric |
Show Rants Commands |
Numeric |
Show Keys Commands |
Numeric |
Show Engine Logs Commands |
Numeric |
Show Master Status Commands |
Numeric |
Show New Master Commands |
Numeric |
Show Open Tables Commands |
Numeric |
Show Processlist Commands |
Numeric |
Show Slave Hosts Commands |
Numeric |
Show Slave Status Commands |
Numeric |
Show Tables Commands |
Numeric |
Show Variables Commands |
Numeric |
Show Status Commands |
Numeric |
Begin Transactions Commands |
Numeric |
Commit Transactions Commands |
Numeric |
Lock Tables Commands |
Numeric |
Rollback Transactions Commands |
Numeric |
Unlock Tables Commands |
Numeric |
Buffer Pool Pages Data |
Numeric |
Buffer Pool Dirty Pages |
Numeric |
Buffer Pool Flush Page |
Numeric |
Buffer Pool Free Pages |
Numeric |
Buffer Pool Misc Pages |
Numeric |
Buffer Pool Pages |
Numeric |
Buffer Pool Reads Random Ahead |
Numeric |
Buffer Pool Sequential Reads |
Numeric |
Buffer Pool Read Requests |
Numeric |
Buffer Pool Reads |
Numeric |
Buffer Pool Wait Free |
Numeric |
Buffer Pool Write Requests |
Numeric |
Data Fsyncs |
Numeric |
Data Pending Fsyncs |
Numeric |
Data Pending Reads |
Numeric |
Data Pending Writes |
Numeric |
Data Reads |
Numeric |
Data Writes |
Numeric |
Data Written |
Numeric |
Double Write Written Pages |
Numeric |
Double Write Writes |
Numeric |
Log Waits |
Numeric |
Log Write Requests |
Numeric |
Log Writes |
Numeric |
OS Log Fsyncs |
Numeric |
OS Log Pending Fsyncs |
Numeric |
OS Log Pending Writes |
Numeric |
OS Log Written |
Numeric |
Page Size (KB) |
Numeric |
Created Pages |
Numeric |
Read Pages |
Numeric |
Innodb Written Pages |
Numeric |
Row Lock Current Waits |
Numeric |
Row Lock Time |
Numeric |
Average Row Lock Time |
Numeric |
Row Lock Waits |
Numeric |
Deleted Innodb Rows |
Numeric |
Inserted Innodb Rows |
Numeric |
Innodb Read Rows |
Numeric |
Innodb Updated Rows |
Numeric |
Sent Bytes/sec |
Numeric |
Key Read Requests/sec |
Numeric |
Key Write Requests/sec |
Numeric |
Key Writes/sec |
Numeric |
Key Reads/sec |
Numeric |
Select Commands/sec |
Numeric |
Delete Commands/sec |
Numeric |
Insert Commands/sec |
Numeric |
Update Commands/sec |
Numeric |
Commit Transactions Commands/sec |
Numeric |
Rollback Transactions Commands/sec |
Numeric |
Lock Tables Commands/sec |
Numeric |
Unlock Tables Commands/sec |
Numeric |
Begin Transactions Commands/sec |
Numeric |
Kill Commands/sec |
Numeric |
Buffer Pool Sequential Reads/sec |
Numeric |
Buffer Pool Read Requests/sec |
Numeric |
Buffer Pool Reads/sec |
Numeric |
Buffer Pool Write Requests/sec |
Numeric |
Data Reads/sec |
Numeric |
Data Writes/sec |
Numeric |
Deleted Innodb Rows/sec |
Numeric |
Inserted Innodb Rows/sec |
Numeric |
Read Rows/sec |
Numeric |
Updated Rows/sec |
Numeric |
Created Pages/sec |
Numeric |
Read Pages/sec |
Numeric |
Innodb Written Pages/sec |
Numeric |
Received Byte/sec |
Numeric |